package com.fz.mapper;

import com.fz.entity.College;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Z-C-Y on 2018-03-08.
 * artist.jsp===艺术家 后台管理
 */
public interface AdminArtistMapper {
    /*根据id进行删除字段*/
    @Delete("delete from college where id = #{deleteID}")
    public int deleteCollege(@Param("deleteID") int deleteID);

    /*添加字段*/
    @Insert("insert into college(s_name) values(#{add})")
   public int addCollege(@Param("add") String add);

    /*拿到-艺术家--查询条件--毕业美院*/
    @Select("select * from college")
    public List<College> queryCollege();

}
